TaskAddTrigger

EntityType | Independent
Logical Entity Name | TaskAddTrigger
Default Table Name | cmActions
Logical Only | NO
Owner | dbo
Definition |
Note |

TaskAddTrigger Attributes

Attribute/Logical Rolename | Domain | Datatype | NULL | Definition
Code |  | CHAR(8) | NO |
Name |  | VARCHAR(50) | NO |
TaskDocumentScheduleBasedOnEntityId |  | INTEGER | NO |
TaskDocumentScheduleEventTriggerId |  | INTEGER | NO |
SchoolStatusId |  | INTEGER | YES |
TriggerTaskTemplateId |  | INTEGER | NO |
LeadTypeId |  | INTEGER | NO |
TaskTypeId |  | INTEGER | NO |
TaskTemplateId |  | INTEGER | NO |
TaskAssignToListId |  | INTEGER | NO |
AssignToStaffId |  | INTEGER | NO |
AddTaskTimeFrame |  | INTEGER | NO |
AddTaskTimeUnit |  | SMALLINT | NO |
IsAddTaskTimeUnitBefore |  | BIT | NO |
TaskAddTriggerTimeFrameTypeId |  | INTEGER | NO |
IsActive |  | BIT | NO |
IsRequired |  | BIT | NO |
IsSystemCode |  | BIT | NO |
LastModifiedUserId |  | INTEGER | NO |
CreatedDateTime |  | DATETIME | NO |
LastModifiedDateTime |  | DATETIME | NO |
RowVersion |  | TIMESTAMP/DATE | NO |
TaskAddTriggerId |  | INTEGER | NO |
CampusGroupId |  | INTEGER | YES |
AssignToCode |  | CHAR(1) | YES |
StaffGroupId |  | INTEGER | YES |
DocumentTypeId |  | INTEGER | YES |
PreviousSchoolStatusId |  | INTEGER | YES |
ProcessType |  | CHAR(1) | YES |
DocumentTypeListId |  | INTEGER | YES |
DocumentTypeIdList |  | VARCHAR(4000) | YES |

TaskAddTrigger Keys

Key Name | Key Type | Keys
cmActions_cmObjectID_N_N_IDX | Inversion Entry | TaskDocumentScheduleBasedOnEntityId
cmActions_cmObjectEventID_N_N_IDX | Inversion Entry | TaskDocumentScheduleEventTriggerId
cmActions_CmDocTypeID_N_N_IDX | Inversion Entry | DocumentTypeId
cmActions_cmDateID_N_N_IDX | Inversion Entry | TaskAddTriggerTimeFrameTypeId
cmActions_SyStaffID_N_N_IDX | Inversion Entry | AssignToStaffId
cmActions_SyStaffGroupID_N_N_IDX | Inversion Entry | StaffGroupId
cmActions_cmTemplateAssignTo_N_N_IDX | Inversion Entry | TaskAssignToListId
cmActions_cmActionsID_U_C_IDX | PrimaryKey | TaskAddTriggerId

TaskAddTrigger Relationships

Parent Relationships:

Entity Name | Type | Cardinality | Business Name | VerbPhrase | InversePhrase | Foreign Keys | Is Supertype
TaskAddTriggerTimeFrameType | Non-Identifying | One To Zero or More |  |  |  | TaskAddTriggerTimeFrameTypeId | NO
DocumentType | Non-Identifying | Zero or One to Zero or More |  |  |  | DocumentTypeId | NO
TaskDocumentScheduleEventTrigger | Non-Identifying | One To Zero or More |  |  |  | TaskDocumentScheduleEventTriggerId | NO
TaskDocumentScheduleBasedOnEntity | Non-Identifying | One To Zero or More |  |  |  | TaskDocumentScheduleBasedOnEntityId | NO
TaskAssignToList | Non-Identifying | One To Zero or More |  |  |  | TaskAssignToListId | NO
StaffGroup | Non-Identifying | Zero or One to Zero or More |  |  |  | StaffGroupId | NO
Staff | Non-Identifying | One To Zero or More |  |  |  | AssignToStaffId | NO
DocumentTypeList | Non-Identifying | Zero or One to Zero or More |  |  |  | DocumentTypeListId | NO
TaskDocumentScheduleEventTrigger | Non-Identifying | Zero or One to Zero or More |  |  |  | TaskDocumentScheduleEventTriggerId | NO

Child Relationships:

Entity Name | Type | Cardinality | Business Name | VerbPhrase | InversePhrase | Foreign Keys | Is Subtype
TaskAddTriggerSchoolStatus | Non-Identifying | One To Zero or More |  |  |  |  | NO
CmActionsFundSourceDetail | Non-Identifying | One To Zero or More |  |  |  |  | NO
Document | Non-Identifying | One To Zero or More |  |  |  |  | NO
Document | Non-Identifying | One To Zero or More |  |  |  |  | NO

TaskAddTrigger Check Constraints

Check Constraint Name | CheckConstraint

TaskAddTrigger Where Used - Model Usage

Mapped Object | Is User Defined? | Denormalization Mappings | Description | Bound Attachments
Logical dbo.TaskAddTrigger | NO |  |  |
Physical (Microsoft SQL Server) dbo.cmActions | NO |  |  |

TaskAddTrigger Where Used - Submodel Usage

Model | Submodel Usage
Logical | Main Model
Logical | Documents
Physical (Microsoft SQL Server) | Main Model
Physical (Microsoft SQL Server) | Career Services

TaskAddTrigger Data Movement Rules

Name | Type | Rule Text/Value